package droid.insane.database;

/**
 * @author Sandamal
 *All the constants used by the database are in this class
 */
public class DbConstants {
	// Table name - market_data
	public static final String TABLE_MARKET_DATA = "market_data";
	// Column names
	public static final String COLUMN_SYMBOL = "symbol";
	public static final String COLUMN_COMPANY_NAME = "company_name";
	public static final String COLUMN_SHARE_VOLUME = "share_volume";
	public static final String COLUMN_TRADE_VOLUME = "trade_volume";
	public static final String COLUMN_PREV_CLOSE = "previous_close";
	public static final String COLUMN_OPEN = "open";
	public static final String COLUMN_HIGH = "high";
	public static final String COLUMN_LOW = "low";
	public static final String COLUMN_LAST_TRADED_PRICE = "last_traded_price";
	public static final String COLUMN_CHANGE_RS = "change_rs";
	public static final String COLUMN_CHANGE_PRECENTAGE = "change_precentage";
	public static final String COLUMN_UP_OR_DOWN = "up_or_down";

	// Table name - portfolio_name
	public static final String TABLE_PORTFOLIO_NAME = "portfolio_name";
	// Column names
	public static final String COLUMN_PORTFOLIO_NAME = "portfolio_name";

	// Table name - transaction_portfolio
	public static final String TABLE_TRANSACTION_PORTFOLIO = "transaction_portfolio";

	// Table name - portfolio
	public static final String TABLE_PORTFOLIO = "portfolio";
	// Column names
	public static final String COLUMN_PORTFOLIO_ID = "portfolio_id";
	public static final String COLUMN_STOCK = "stock";
	public static final String COLUMN_QUANTITY = "quantity";
	public static final String COLUMN_COST = "cost";

	// Table name - transaction
	public static final String TABLE_TRANSACTION = "transaction";
	// Column names
	public static final String COLUMN_TRANSACTION_ID = "transaction_id";
	public static final String COLUMN_TYPE = "type";
	public static final String COLUMN_PRICE = "price";

	public static final String BUY = "buy";
	public static final String SELL = "sell";
	public static final String ROW_ID = "rowid";

}
